Release 10.1A: OpenEdge Data Management:
Database Administration

Maximum JTA Transactions (-maxxids)

Operating system and syntax	UNIX Windows	-maxxxids n
Use with	Maximum value	Minimum value1	Single-user default	Multi-user default2
DBS	32,000	0, (users)/2	–	0, 100

1For a JTA-enabled database, the minimum value is (users)/2 where users is the value of the -n startup parameter. For a database not enabled for JTA, the minimum is 0. 2For a JTA-enabled database, the default is 100. For a database not enabled for JTA, the default is 0.

n

The maximum number of simultaneous JTA transactions allowed.

JTA transactions rely on an external transaction manager to control transaction commit and rollback. OpenEdge SQL supports the Java Transaction API (JTA) thus enabling the database to function as a resource manager as defined in the J2EE framework architecture. Because the transactions are controlled by an external transaction manager, they may take a long time to complete. Use the Maximum JTA Transactions parameter (-maxxids) to control the number of JTA transactions simultaneously allowed.